How to access stdClass variables stdClass Object([max(id)])=>64)

Posted by Theopile on Stack Overflow See other posts from Stack Overflow or by Theopile
Published on 2010-06-12T15:17:54Z Indexed on 2010/06/12 15:22 UTC
Read the original article Hit count: 334

Filed under:
|
|
|

I need the very last valid entry in a database table which would be the row with the greatest primary key. So using mysqli, my query is "SELECT MAX(id) FROM table LIMIT 1". This query returns the correct number(using print_r()) but I cannot figure out how to access it. Here is the main code. Note that the $this->link refers to class with a mysqli connection.

$q="select max(id) from stones limit 1";
    $qed=$this->link->query($q) or die(mysqli_error());
    if($qed){
        $row=$qed->fetch_object();
        print_r($row);
        echo $lastid=$row;//here is the problem
    }

The valid line print_r($row) echos out "stdClass Object ( [max(id)] => 68 )"

© Stack Overflow or respective owner

Related posts about php

Related posts about mysql